CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_peer_business(
id                                                 bigint                         COMMENT '',
version                                            Double                         COMMENT '',
createtime                                         String                         COMMENT '',
lastupdatetime                                     String                         COMMENT '',
serviceSiteCode                                    String                         COMMENT '',
spCode                                             String                         COMMENT '',
expressCode                                        String                         COMMENT '',
expressName                                        String                         COMMENT '',
stationId                                          String                         COMMENT '',
status                                             Double                         COMMENT '1-已开通,0-审核中，-1-未开通'
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_peer_business'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);